<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" pageEncoding="UTF-8" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core_rt" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jstl/fmt_rt" %>

<html>
<head>
    <title>登录页</title>
    <%--echart线图、柱状图、饼图等各种图型库 cdn--%>
    <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/echarts/dist/echarts.min.js"></script>
    <%--jquery cdn--%>
    <script type="text/javascript" src="https://cdn.bootcdn.net/ajax/libs/jquery/3.6.1/jquery.js"></script>
</head>
<body>

学生小组 <input name="group"><br>

<button onclick="zxt()">点击展示 折线图</button>
<button onclick="zzt()">点击展示 柱状图</button>
<button onclick="bing()">点击展示 饼图(不带小组条件)</button>
<button onclick="excel()">点击导出excel</button>
<%-- 报表的容器--%>
<div id="main" style="height: 500px;width: 500px"></div>
</body>

<script>

    function excel() {
        let group = $('[name=group]').val();
        // 发起一个网络get请求
        window.location.href='/excel.do?group=' + group

    }


    function zxt() {
        let group = $('[name=group]').val();

        $.ajax({
            url: '/zxt.do?group=' + group,
            success: function (data) {
                console.log('从数据库查出的统计数据：', data)

                var x = []
                var y = []
                for (let i = 0; i < data.length; i++) {
                    let xdata = data[i].xdata;
                    x.push(xdata)
                    let ydata = data[i].ydata;
                    y.push(ydata)
                }
                var chartDom = document.getElementById('main');
                var myChart = echarts.init(chartDom);
                var option;

                option = {
                    xAxis: {
                        type: 'category',
                        data: x
                    },
                    yAxis: {
                        type: 'value'
                    },
                    series: [
                        {
                            data: y,
                            type: 'line'
                        }
                    ]
                };

                option && myChart.setOption(option);


            }
        })
    }


    function zzt() {

        let group = $('[name=group]').val();
        $.ajax({
            url: '/zxt.do?group=' + group,
            success: function (data) {
                console.log('从数据库查出的统计数据：', data)

                var x = []
                var y = []
                for (let i = 0; i < data.length; i++) {
                    let xdata = data[i].xdata;
                    x.push(xdata)
                    let ydata = data[i].ydata;
                    y.push(ydata)
                }
                var chartDom = document.getElementById('main');
                var myChart = echarts.init(chartDom);
                var option;

                option = {
                    xAxis: {
                        type: 'category',
                        data: x
                    },
                    yAxis: {
                        type: 'value'
                    },
                    series: [
                        {
                            data: y,
                            type: 'bar',
                            showBackground: true,
                            backgroundStyle: {
                                color: 'rgba(180, 180, 180, 0.2)'
                            }
                        }
                    ]
                };

                option && myChart.setOption(option);

            }
        })
    }


    function bing() {

        $.ajax({
            url: '/bing.do',
            success: function (data) {
                console.log("饼图查询到的数据 ", data)

                var chartDom = document.getElementById('main');
                var myChart = echarts.init(chartDom);
                var option;

                option = {
                    title: {
                        text: 'Referer of a Website',
                        subtext: 'Fake Data',
                        left: 'center'
                    },
                    tooltip: {
                        trigger: 'item'
                    },
                    legend: {
                        orient: 'vertical',
                        left: 'left'
                    },
                    series: [
                        {
                            name: 'Access From',
                            type: 'pie',
                            radius: '50%',
                            data: data,
                            emphasis: {
                                itemStyle: {
                                    shadowBlur: 10,
                                    shadowOffsetX: 0,
                                    shadowColor: 'rgba(0, 0, 0, 0.5)'
                                }
                            }
                        }
                    ]
                };

                option && myChart.setOption(option);
            }
        })


    }
</script>
</html>